package com.ygqh.baby.po;

import java.math.BigDecimal;
import java.util.ArrayList;
import java.util.List;

public class YgOrderDetailExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    public YgOrderDetailExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andIdIsNull() {
            addCriterion("id is null");
            return (Criteria) this;
        }

        public Criteria andIdIsNotNull() {
            addCriterion("id is not null");
            return (Criteria) this;
        }

        public Criteria andIdEqualTo(Long value) {
            addCriterion("id =", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotEqualTo(Long value) {
            addCriterion("id <>", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThan(Long value) {
            addCriterion("id >", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThanOrEqualTo(Long value) {
            addCriterion("id >=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThan(Long value) {
            addCriterion("id <", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThanOrEqualTo(Long value) {
            addCriterion("id <=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdIn(List<Long> values) {
            addCriterion("id in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotIn(List<Long> values) {
            addCriterion("id not in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdBetween(Long value1, Long value2) {
            addCriterion("id between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotBetween(Long value1, Long value2) {
            addCriterion("id not between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andOrderIdIsNull() {
            addCriterion("order_id is null");
            return (Criteria) this;
        }

        public Criteria andOrderIdIsNotNull() {
            addCriterion("order_id is not null");
            return (Criteria) this;
        }

        public Criteria andOrderIdEqualTo(Long value) {
            addCriterion("order_id =", value, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdNotEqualTo(Long value) {
            addCriterion("order_id <>", value, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdGreaterThan(Long value) {
            addCriterion("order_id >", value, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdGreaterThanOrEqualTo(Long value) {
            addCriterion("order_id >=", value, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdLessThan(Long value) {
            addCriterion("order_id <", value, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdLessThanOrEqualTo(Long value) {
            addCriterion("order_id <=", value, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdIn(List<Long> values) {
            addCriterion("order_id in", values, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdNotIn(List<Long> values) {
            addCriterion("order_id not in", values, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdBetween(Long value1, Long value2) {
            addCriterion("order_id between", value1, value2, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdNotBetween(Long value1, Long value2) {
            addCriterion("order_id not between", value1, value2, "orderId");
            return (Criteria) this;
        }

        public Criteria andOutCodeIsNull() {
            addCriterion("out_code is null");
            return (Criteria) this;
        }

        public Criteria andOutCodeIsNotNull() {
            addCriterion("out_code is not null");
            return (Criteria) this;
        }

        public Criteria andOutCodeEqualTo(String value) {
            addCriterion("out_code =", value, "outCode");
            return (Criteria) this;
        }

        public Criteria andOutCodeNotEqualTo(String value) {
            addCriterion("out_code <>", value, "outCode");
            return (Criteria) this;
        }

        public Criteria andOutCodeGreaterThan(String value) {
            addCriterion("out_code >", value, "outCode");
            return (Criteria) this;
        }

        public Criteria andOutCodeGreaterThanOrEqualTo(String value) {
            addCriterion("out_code >=", value, "outCode");
            return (Criteria) this;
        }

        public Criteria andOutCodeLessThan(String value) {
            addCriterion("out_code <", value, "outCode");
            return (Criteria) this;
        }

        public Criteria andOutCodeLessThanOrEqualTo(String value) {
            addCriterion("out_code <=", value, "outCode");
            return (Criteria) this;
        }

        public Criteria andOutCodeLike(String value) {
            addCriterion("out_code like", value, "outCode");
            return (Criteria) this;
        }

        public Criteria andOutCodeNotLike(String value) {
            addCriterion("out_code not like", value, "outCode");
            return (Criteria) this;
        }

        public Criteria andOutCodeIn(List<String> values) {
            addCriterion("out_code in", values, "outCode");
            return (Criteria) this;
        }

        public Criteria andOutCodeNotIn(List<String> values) {
            addCriterion("out_code not in", values, "outCode");
            return (Criteria) this;
        }

        public Criteria andOutCodeBetween(String value1, String value2) {
            addCriterion("out_code between", value1, value2, "outCode");
            return (Criteria) this;
        }

        public Criteria andOutCodeNotBetween(String value1, String value2) {
            addCriterion("out_code not between", value1, value2, "outCode");
            return (Criteria) this;
        }

        public Criteria andSkuIdIsNull() {
            addCriterion("sku_id is null");
            return (Criteria) this;
        }

        public Criteria andSkuIdIsNotNull() {
            addCriterion("sku_id is not null");
            return (Criteria) this;
        }

        public Criteria andSkuIdEqualTo(Long value) {
            addCriterion("sku_id =", value, "skuId");
            return (Criteria) this;
        }

        public Criteria andSkuIdNotEqualTo(Long value) {
            addCriterion("sku_id <>", value, "skuId");
            return (Criteria) this;
        }

        public Criteria andSkuIdGreaterThan(Long value) {
            addCriterion("sku_id >", value, "skuId");
            return (Criteria) this;
        }

        public Criteria andSkuIdGreaterThanOrEqualTo(Long value) {
            addCriterion("sku_id >=", value, "skuId");
            return (Criteria) this;
        }

        public Criteria andSkuIdLessThan(Long value) {
            addCriterion("sku_id <", value, "skuId");
            return (Criteria) this;
        }

        public Criteria andSkuIdLessThanOrEqualTo(Long value) {
            addCriterion("sku_id <=", value, "skuId");
            return (Criteria) this;
        }

        public Criteria andSkuIdIn(List<Long> values) {
            addCriterion("sku_id in", values, "skuId");
            return (Criteria) this;
        }

        public Criteria andSkuIdNotIn(List<Long> values) {
            addCriterion("sku_id not in", values, "skuId");
            return (Criteria) this;
        }

        public Criteria andSkuIdBetween(Long value1, Long value2) {
            addCriterion("sku_id between", value1, value2, "skuId");
            return (Criteria) this;
        }

        public Criteria andSkuIdNotBetween(Long value1, Long value2) {
            addCriterion("sku_id not between", value1, value2, "skuId");
            return (Criteria) this;
        }

        public Criteria andSkuCodeIsNull() {
            addCriterion("sku_code is null");
            return (Criteria) this;
        }

        public Criteria andSkuCodeIsNotNull() {
            addCriterion("sku_code is not null");
            return (Criteria) this;
        }

        public Criteria andSkuCodeEqualTo(String value) {
            addCriterion("sku_code =", value, "skuCode");
            return (Criteria) this;
        }

        public Criteria andSkuCodeNotEqualTo(String value) {
            addCriterion("sku_code <>", value, "skuCode");
            return (Criteria) this;
        }

        public Criteria andSkuCodeGreaterThan(String value) {
            addCriterion("sku_code >", value, "skuCode");
            return (Criteria) this;
        }

        public Criteria andSkuCodeGreaterThanOrEqualTo(String value) {
            addCriterion("sku_code >=", value, "skuCode");
            return (Criteria) this;
        }

        public Criteria andSkuCodeLessThan(String value) {
            addCriterion("sku_code <", value, "skuCode");
            return (Criteria) this;
        }

        public Criteria andSkuCodeLessThanOrEqualTo(String value) {
            addCriterion("sku_code <=", value, "skuCode");
            return (Criteria) this;
        }

        public Criteria andSkuCodeLike(String value) {
            addCriterion("sku_code like", value, "skuCode");
            return (Criteria) this;
        }

        public Criteria andSkuCodeNotLike(String value) {
            addCriterion("sku_code not like", value, "skuCode");
            return (Criteria) this;
        }

        public Criteria andSkuCodeIn(List<String> values) {
            addCriterion("sku_code in", values, "skuCode");
            return (Criteria) this;
        }

        public Criteria andSkuCodeNotIn(List<String> values) {
            addCriterion("sku_code not in", values, "skuCode");
            return (Criteria) this;
        }

        public Criteria andSkuCodeBetween(String value1, String value2) {
            addCriterion("sku_code between", value1, value2, "skuCode");
            return (Criteria) this;
        }

        public Criteria andSkuCodeNotBetween(String value1, String value2) {
            addCriterion("sku_code not between", value1, value2, "skuCode");
            return (Criteria) this;
        }

        public Criteria andSupplierIdIsNull() {
            addCriterion("supplier_id is null");
            return (Criteria) this;
        }

        public Criteria andSupplierIdIsNotNull() {
            addCriterion("supplier_id is not null");
            return (Criteria) this;
        }

        public Criteria andSupplierIdEqualTo(Long value) {
            addCriterion("supplier_id =", value, "supplierId");
            return (Criteria) this;
        }

        public Criteria andSupplierIdNotEqualTo(Long value) {
            addCriterion("supplier_id <>", value, "supplierId");
            return (Criteria) this;
        }

        public Criteria andSupplierIdGreaterThan(Long value) {
            addCriterion("supplier_id >", value, "supplierId");
            return (Criteria) this;
        }

        public Criteria andSupplierIdGreaterThanOrEqualTo(Long value) {
            addCriterion("supplier_id >=", value, "supplierId");
            return (Criteria) this;
        }

        public Criteria andSupplierIdLessThan(Long value) {
            addCriterion("supplier_id <", value, "supplierId");
            return (Criteria) this;
        }

        public Criteria andSupplierIdLessThanOrEqualTo(Long value) {
            addCriterion("supplier_id <=", value, "supplierId");
            return (Criteria) this;
        }

        public Criteria andSupplierIdIn(List<Long> values) {
            addCriterion("supplier_id in", values, "supplierId");
            return (Criteria) this;
        }

        public Criteria andSupplierIdNotIn(List<Long> values) {
            addCriterion("supplier_id not in", values, "supplierId");
            return (Criteria) this;
        }

        public Criteria andSupplierIdBetween(Long value1, Long value2) {
            addCriterion("supplier_id between", value1, value2, "supplierId");
            return (Criteria) this;
        }

        public Criteria andSupplierIdNotBetween(Long value1, Long value2) {
            addCriterion("supplier_id not between", value1, value2, "supplierId");
            return (Criteria) this;
        }

        public Criteria andProductNameIsNull() {
            addCriterion("product_name is null");
            return (Criteria) this;
        }

        public Criteria andProductNameIsNotNull() {
            addCriterion("product_name is not null");
            return (Criteria) this;
        }

        public Criteria andProductNameEqualTo(String value) {
            addCriterion("product_name =", value, "productName");
            return (Criteria) this;
        }

        public Criteria andProductNameNotEqualTo(String value) {
            addCriterion("product_name <>", value, "productName");
            return (Criteria) this;
        }

        public Criteria andProductNameGreaterThan(String value) {
            addCriterion("product_name >", value, "productName");
            return (Criteria) this;
        }

        public Criteria andProductNameGreaterThanOrEqualTo(String value) {
            addCriterion("product_name >=", value, "productName");
            return (Criteria) this;
        }

        public Criteria andProductNameLessThan(String value) {
            addCriterion("product_name <", value, "productName");
            return (Criteria) this;
        }

        public Criteria andProductNameLessThanOrEqualTo(String value) {
            addCriterion("product_name <=", value, "productName");
            return (Criteria) this;
        }

        public Criteria andProductNameLike(String value) {
            addCriterion("product_name like", value, "productName");
            return (Criteria) this;
        }

        public Criteria andProductNameNotLike(String value) {
            addCriterion("product_name not like", value, "productName");
            return (Criteria) this;
        }

        public Criteria andProductNameIn(List<String> values) {
            addCriterion("product_name in", values, "productName");
            return (Criteria) this;
        }

        public Criteria andProductNameNotIn(List<String> values) {
            addCriterion("product_name not in", values, "productName");
            return (Criteria) this;
        }

        public Criteria andProductNameBetween(String value1, String value2) {
            addCriterion("product_name between", value1, value2, "productName");
            return (Criteria) this;
        }

        public Criteria andProductNameNotBetween(String value1, String value2) {
            addCriterion("product_name not between", value1, value2, "productName");
            return (Criteria) this;
        }

        public Criteria andShortNameIsNull() {
            addCriterion("short_name is null");
            return (Criteria) this;
        }

        public Criteria andShortNameIsNotNull() {
            addCriterion("short_name is not null");
            return (Criteria) this;
        }

        public Criteria andShortNameEqualTo(String value) {
            addCriterion("short_name =", value, "shortName");
            return (Criteria) this;
        }

        public Criteria andShortNameNotEqualTo(String value) {
            addCriterion("short_name <>", value, "shortName");
            return (Criteria) this;
        }

        public Criteria andShortNameGreaterThan(String value) {
            addCriterion("short_name >", value, "shortName");
            return (Criteria) this;
        }

        public Criteria andShortNameGreaterThanOrEqualTo(String value) {
            addCriterion("short_name >=", value, "shortName");
            return (Criteria) this;
        }

        public Criteria andShortNameLessThan(String value) {
            addCriterion("short_name <", value, "shortName");
            return (Criteria) this;
        }

        public Criteria andShortNameLessThanOrEqualTo(String value) {
            addCriterion("short_name <=", value, "shortName");
            return (Criteria) this;
        }

        public Criteria andShortNameLike(String value) {
            addCriterion("short_name like", value, "shortName");
            return (Criteria) this;
        }

        public Criteria andShortNameNotLike(String value) {
            addCriterion("short_name not like", value, "shortName");
            return (Criteria) this;
        }

        public Criteria andShortNameIn(List<String> values) {
            addCriterion("short_name in", values, "shortName");
            return (Criteria) this;
        }

        public Criteria andShortNameNotIn(List<String> values) {
            addCriterion("short_name not in", values, "shortName");
            return (Criteria) this;
        }

        public Criteria andShortNameBetween(String value1, String value2) {
            addCriterion("short_name between", value1, value2, "shortName");
            return (Criteria) this;
        }

        public Criteria andShortNameNotBetween(String value1, String value2) {
            addCriterion("short_name not between", value1, value2, "shortName");
            return (Criteria) this;
        }

        public Criteria andSalePriceIsNull() {
            addCriterion("sale_price is null");
            return (Criteria) this;
        }

        public Criteria andSalePriceIsNotNull() {
            addCriterion("sale_price is not null");
            return (Criteria) this;
        }

        public Criteria andSalePriceEqualTo(BigDecimal value) {
            addCriterion("sale_price =", value, "salePrice");
            return (Criteria) this;
        }

        public Criteria andSalePriceNotEqualTo(BigDecimal value) {
            addCriterion("sale_price <>", value, "salePrice");
            return (Criteria) this;
        }

        public Criteria andSalePriceGreaterThan(BigDecimal value) {
            addCriterion("sale_price >", value, "salePrice");
            return (Criteria) this;
        }

        public Criteria andSalePriceGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("sale_price >=", value, "salePrice");
            return (Criteria) this;
        }

        public Criteria andSalePriceLessThan(BigDecimal value) {
            addCriterion("sale_price <", value, "salePrice");
            return (Criteria) this;
        }

        public Criteria andSalePriceLessThanOrEqualTo(BigDecimal value) {
            addCriterion("sale_price <=", value, "salePrice");
            return (Criteria) this;
        }

        public Criteria andSalePriceIn(List<BigDecimal> values) {
            addCriterion("sale_price in", values, "salePrice");
            return (Criteria) this;
        }

        public Criteria andSalePriceNotIn(List<BigDecimal> values) {
            addCriterion("sale_price not in", values, "salePrice");
            return (Criteria) this;
        }

        public Criteria andSalePriceBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("sale_price between", value1, value2, "salePrice");
            return (Criteria) this;
        }

        public Criteria andSalePriceNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("sale_price not between", value1, value2, "salePrice");
            return (Criteria) this;
        }

        public Criteria andSizeIsNull() {
            addCriterion("size is null");
            return (Criteria) this;
        }

        public Criteria andSizeIsNotNull() {
            addCriterion("size is not null");
            return (Criteria) this;
        }

        public Criteria andSizeEqualTo(String value) {
            addCriterion("size =", value, "size");
            return (Criteria) this;
        }

        public Criteria andSizeNotEqualTo(String value) {
            addCriterion("size <>", value, "size");
            return (Criteria) this;
        }

        public Criteria andSizeGreaterThan(String value) {
            addCriterion("size >", value, "size");
            return (Criteria) this;
        }

        public Criteria andSizeGreaterThanOrEqualTo(String value) {
            addCriterion("size >=", value, "size");
            return (Criteria) this;
        }

        public Criteria andSizeLessThan(String value) {
            addCriterion("size <", value, "size");
            return (Criteria) this;
        }

        public Criteria andSizeLessThanOrEqualTo(String value) {
            addCriterion("size <=", value, "size");
            return (Criteria) this;
        }

        public Criteria andSizeLike(String value) {
            addCriterion("size like", value, "size");
            return (Criteria) this;
        }

        public Criteria andSizeNotLike(String value) {
            addCriterion("size not like", value, "size");
            return (Criteria) this;
        }

        public Criteria andSizeIn(List<String> values) {
            addCriterion("size in", values, "size");
            return (Criteria) this;
        }

        public Criteria andSizeNotIn(List<String> values) {
            addCriterion("size not in", values, "size");
            return (Criteria) this;
        }

        public Criteria andSizeBetween(String value1, String value2) {
            addCriterion("size between", value1, value2, "size");
            return (Criteria) this;
        }

        public Criteria andSizeNotBetween(String value1, String value2) {
            addCriterion("size not between", value1, value2, "size");
            return (Criteria) this;
        }

        public Criteria andImageUrlIsNull() {
            addCriterion("image_url is null");
            return (Criteria) this;
        }

        public Criteria andImageUrlIsNotNull() {
            addCriterion("image_url is not null");
            return (Criteria) this;
        }

        public Criteria andImageUrlEqualTo(String value) {
            addCriterion("image_url =", value, "imageUrl");
            return (Criteria) this;
        }

        public Criteria andImageUrlNotEqualTo(String value) {
            addCriterion("image_url <>", value, "imageUrl");
            return (Criteria) this;
        }

        public Criteria andImageUrlGreaterThan(String value) {
            addCriterion("image_url >", value, "imageUrl");
            return (Criteria) this;
        }

        public Criteria andImageUrlGreaterThanOrEqualTo(String value) {
            addCriterion("image_url >=", value, "imageUrl");
            return (Criteria) this;
        }

        public Criteria andImageUrlLessThan(String value) {
            addCriterion("image_url <", value, "imageUrl");
            return (Criteria) this;
        }

        public Criteria andImageUrlLessThanOrEqualTo(String value) {
            addCriterion("image_url <=", value, "imageUrl");
            return (Criteria) this;
        }

        public Criteria andImageUrlLike(String value) {
            addCriterion("image_url like", value, "imageUrl");
            return (Criteria) this;
        }

        public Criteria andImageUrlNotLike(String value) {
            addCriterion("image_url not like", value, "imageUrl");
            return (Criteria) this;
        }

        public Criteria andImageUrlIn(List<String> values) {
            addCriterion("image_url in", values, "imageUrl");
            return (Criteria) this;
        }

        public Criteria andImageUrlNotIn(List<String> values) {
            addCriterion("image_url not in", values, "imageUrl");
            return (Criteria) this;
        }

        public Criteria andImageUrlBetween(String value1, String value2) {
            addCriterion("image_url between", value1, value2, "imageUrl");
            return (Criteria) this;
        }

        public Criteria andImageUrlNotBetween(String value1, String value2) {
            addCriterion("image_url not between", value1, value2, "imageUrl");
            return (Criteria) this;
        }

        public Criteria andQuantityIsNull() {
            addCriterion("quantity is null");
            return (Criteria) this;
        }

        public Criteria andQuantityIsNotNull() {
            addCriterion("quantity is not null");
            return (Criteria) this;
        }

        public Criteria andQuantityEqualTo(Long value) {
            addCriterion("quantity =", value, "quantity");
            return (Criteria) this;
        }

        public Criteria andQuantityNotEqualTo(Long value) {
            addCriterion("quantity <>", value, "quantity");
            return (Criteria) this;
        }

        public Criteria andQuantityGreaterThan(Long value) {
            addCriterion("quantity >", value, "quantity");
            return (Criteria) this;
        }

        public Criteria andQuantityGreaterThanOrEqualTo(Long value) {
            addCriterion("quantity >=", value, "quantity");
            return (Criteria) this;
        }

        public Criteria andQuantityLessThan(Long value) {
            addCriterion("quantity <", value, "quantity");
            return (Criteria) this;
        }

        public Criteria andQuantityLessThanOrEqualTo(Long value) {
            addCriterion("quantity <=", value, "quantity");
            return (Criteria) this;
        }

        public Criteria andQuantityIn(List<Long> values) {
            addCriterion("quantity in", values, "quantity");
            return (Criteria) this;
        }

        public Criteria andQuantityNotIn(List<Long> values) {
            addCriterion("quantity not in", values, "quantity");
            return (Criteria) this;
        }

        public Criteria andQuantityBetween(Long value1, Long value2) {
            addCriterion("quantity between", value1, value2, "quantity");
            return (Criteria) this;
        }

        public Criteria andQuantityNotBetween(Long value1, Long value2) {
            addCriterion("quantity not between", value1, value2, "quantity");
            return (Criteria) this;
        }

        public Criteria andUnitNameIsNull() {
            addCriterion("unit_name is null");
            return (Criteria) this;
        }

        public Criteria andUnitNameIsNotNull() {
            addCriterion("unit_name is not null");
            return (Criteria) this;
        }

        public Criteria andUnitNameEqualTo(String value) {
            addCriterion("unit_name =", value, "unitName");
            return (Criteria) this;
        }

        public Criteria andUnitNameNotEqualTo(String value) {
            addCriterion("unit_name <>", value, "unitName");
            return (Criteria) this;
        }

        public Criteria andUnitNameGreaterThan(String value) {
            addCriterion("unit_name >", value, "unitName");
            return (Criteria) this;
        }

        public Criteria andUnitNameGreaterThanOrEqualTo(String value) {
            addCriterion("unit_name >=", value, "unitName");
            return (Criteria) this;
        }

        public Criteria andUnitNameLessThan(String value) {
            addCriterion("unit_name <", value, "unitName");
            return (Criteria) this;
        }

        public Criteria andUnitNameLessThanOrEqualTo(String value) {
            addCriterion("unit_name <=", value, "unitName");
            return (Criteria) this;
        }

        public Criteria andUnitNameLike(String value) {
            addCriterion("unit_name like", value, "unitName");
            return (Criteria) this;
        }

        public Criteria andUnitNameNotLike(String value) {
            addCriterion("unit_name not like", value, "unitName");
            return (Criteria) this;
        }

        public Criteria andUnitNameIn(List<String> values) {
            addCriterion("unit_name in", values, "unitName");
            return (Criteria) this;
        }

        public Criteria andUnitNameNotIn(List<String> values) {
            addCriterion("unit_name not in", values, "unitName");
            return (Criteria) this;
        }

        public Criteria andUnitNameBetween(String value1, String value2) {
            addCriterion("unit_name between", value1, value2, "unitName");
            return (Criteria) this;
        }

        public Criteria andUnitNameNotBetween(String value1, String value2) {
            addCriterion("unit_name not between", value1, value2, "unitName");
            return (Criteria) this;
        }

        public Criteria andDetailStatusIsNull() {
            addCriterion("detail_status is null");
            return (Criteria) this;
        }

        public Criteria andDetailStatusIsNotNull() {
            addCriterion("detail_status is not null");
            return (Criteria) this;
        }

        public Criteria andDetailStatusEqualTo(String value) {
            addCriterion("detail_status =", value, "detailStatus");
            return (Criteria) this;
        }

        public Criteria andDetailStatusNotEqualTo(String value) {
            addCriterion("detail_status <>", value, "detailStatus");
            return (Criteria) this;
        }

        public Criteria andDetailStatusGreaterThan(String value) {
            addCriterion("detail_status >", value, "detailStatus");
            return (Criteria) this;
        }

        public Criteria andDetailStatusGreaterThanOrEqualTo(String value) {
            addCriterion("detail_status >=", value, "detailStatus");
            return (Criteria) this;
        }

        public Criteria andDetailStatusLessThan(String value) {
            addCriterion("detail_status <", value, "detailStatus");
            return (Criteria) this;
        }

        public Criteria andDetailStatusLessThanOrEqualTo(String value) {
            addCriterion("detail_status <=", value, "detailStatus");
            return (Criteria) this;
        }

        public Criteria andDetailStatusLike(String value) {
            addCriterion("detail_status like", value, "detailStatus");
            return (Criteria) this;
        }

        public Criteria andDetailStatusNotLike(String value) {
            addCriterion("detail_status not like", value, "detailStatus");
            return (Criteria) this;
        }

        public Criteria andDetailStatusIn(List<String> values) {
            addCriterion("detail_status in", values, "detailStatus");
            return (Criteria) this;
        }

        public Criteria andDetailStatusNotIn(List<String> values) {
            addCriterion("detail_status not in", values, "detailStatus");
            return (Criteria) this;
        }

        public Criteria andDetailStatusBetween(String value1, String value2) {
            addCriterion("detail_status between", value1, value2, "detailStatus");
            return (Criteria) this;
        }

        public Criteria andDetailStatusNotBetween(String value1, String value2) {
            addCriterion("detail_status not between", value1, value2, "detailStatus");
            return (Criteria) this;
        }

        public Criteria andRefundStatusIsNull() {
            addCriterion("refund_status is null");
            return (Criteria) this;
        }

        public Criteria andRefundStatusIsNotNull() {
            addCriterion("refund_status is not null");
            return (Criteria) this;
        }

        public Criteria andRefundStatusEqualTo(String value) {
            addCriterion("refund_status =", value, "refundStatus");
            return (Criteria) this;
        }

        public Criteria andRefundStatusNotEqualTo(String value) {
            addCriterion("refund_status <>", value, "refundStatus");
            return (Criteria) this;
        }

        public Criteria andRefundStatusGreaterThan(String value) {
            addCriterion("refund_status >", value, "refundStatus");
            return (Criteria) this;
        }

        public Criteria andRefundStatusGreaterThanOrEqualTo(String value) {
            addCriterion("refund_status >=", value, "refundStatus");
            return (Criteria) this;
        }

        public Criteria andRefundStatusLessThan(String value) {
            addCriterion("refund_status <", value, "refundStatus");
            return (Criteria) this;
        }

        public Criteria andRefundStatusLessThanOrEqualTo(String value) {
            addCriterion("refund_status <=", value, "refundStatus");
            return (Criteria) this;
        }

        public Criteria andRefundStatusLike(String value) {
            addCriterion("refund_status like", value, "refundStatus");
            return (Criteria) this;
        }

        public Criteria andRefundStatusNotLike(String value) {
            addCriterion("refund_status not like", value, "refundStatus");
            return (Criteria) this;
        }

        public Criteria andRefundStatusIn(List<String> values) {
            addCriterion("refund_status in", values, "refundStatus");
            return (Criteria) this;
        }

        public Criteria andRefundStatusNotIn(List<String> values) {
            addCriterion("refund_status not in", values, "refundStatus");
            return (Criteria) this;
        }

        public Criteria andRefundStatusBetween(String value1, String value2) {
            addCriterion("refund_status between", value1, value2, "refundStatus");
            return (Criteria) this;
        }

        public Criteria andRefundStatusNotBetween(String value1, String value2) {
            addCriterion("refund_status not between", value1, value2, "refundStatus");
            return (Criteria) this;
        }

        public Criteria andSendMarkIsNull() {
            addCriterion("send_mark is null");
            return (Criteria) this;
        }

        public Criteria andSendMarkIsNotNull() {
            addCriterion("send_mark is not null");
            return (Criteria) this;
        }

        public Criteria andSendMarkEqualTo(String value) {
            addCriterion("send_mark =", value, "sendMark");
            return (Criteria) this;
        }

        public Criteria andSendMarkNotEqualTo(String value) {
            addCriterion("send_mark <>", value, "sendMark");
            return (Criteria) this;
        }

        public Criteria andSendMarkGreaterThan(String value) {
            addCriterion("send_mark >", value, "sendMark");
            return (Criteria) this;
        }

        public Criteria andSendMarkGreaterThanOrEqualTo(String value) {
            addCriterion("send_mark >=", value, "sendMark");
            return (Criteria) this;
        }

        public Criteria andSendMarkLessThan(String value) {
            addCriterion("send_mark <", value, "sendMark");
            return (Criteria) this;
        }

        public Criteria andSendMarkLessThanOrEqualTo(String value) {
            addCriterion("send_mark <=", value, "sendMark");
            return (Criteria) this;
        }

        public Criteria andSendMarkLike(String value) {
            addCriterion("send_mark like", value, "sendMark");
            return (Criteria) this;
        }

        public Criteria andSendMarkNotLike(String value) {
            addCriterion("send_mark not like", value, "sendMark");
            return (Criteria) this;
        }

        public Criteria andSendMarkIn(List<String> values) {
            addCriterion("send_mark in", values, "sendMark");
            return (Criteria) this;
        }

        public Criteria andSendMarkNotIn(List<String> values) {
            addCriterion("send_mark not in", values, "sendMark");
            return (Criteria) this;
        }

        public Criteria andSendMarkBetween(String value1, String value2) {
            addCriterion("send_mark between", value1, value2, "sendMark");
            return (Criteria) this;
        }

        public Criteria andSendMarkNotBetween(String value1, String value2) {
            addCriterion("send_mark not between", value1, value2, "sendMark");
            return (Criteria) this;
        }

        public Criteria andPromotionTypeIsNull() {
            addCriterion("promotion_type is null");
            return (Criteria) this;
        }

        public Criteria andPromotionTypeIsNotNull() {
            addCriterion("promotion_type is not null");
            return (Criteria) this;
        }

        public Criteria andPromotionTypeEqualTo(String value) {
            addCriterion("promotion_type =", value, "promotionType");
            return (Criteria) this;
        }

        public Criteria andPromotionTypeNotEqualTo(String value) {
            addCriterion("promotion_type <>", value, "promotionType");
            return (Criteria) this;
        }

        public Criteria andPromotionTypeGreaterThan(String value) {
            addCriterion("promotion_type >", value, "promotionType");
            return (Criteria) this;
        }

        public Criteria andPromotionTypeGreaterThanOrEqualTo(String value) {
            addCriterion("promotion_type >=", value, "promotionType");
            return (Criteria) this;
        }

        public Criteria andPromotionTypeLessThan(String value) {
            addCriterion("promotion_type <", value, "promotionType");
            return (Criteria) this;
        }

        public Criteria andPromotionTypeLessThanOrEqualTo(String value) {
            addCriterion("promotion_type <=", value, "promotionType");
            return (Criteria) this;
        }

        public Criteria andPromotionTypeLike(String value) {
            addCriterion("promotion_type like", value, "promotionType");
            return (Criteria) this;
        }

        public Criteria andPromotionTypeNotLike(String value) {
            addCriterion("promotion_type not like", value, "promotionType");
            return (Criteria) this;
        }

        public Criteria andPromotionTypeIn(List<String> values) {
            addCriterion("promotion_type in", values, "promotionType");
            return (Criteria) this;
        }

        public Criteria andPromotionTypeNotIn(List<String> values) {
            addCriterion("promotion_type not in", values, "promotionType");
            return (Criteria) this;
        }

        public Criteria andPromotionTypeBetween(String value1, String value2) {
            addCriterion("promotion_type between", value1, value2, "promotionType");
            return (Criteria) this;
        }

        public Criteria andPromotionTypeNotBetween(String value1, String value2) {
            addCriterion("promotion_type not between", value1, value2, "promotionType");
            return (Criteria) this;
        }

        public Criteria andForeverRateIsNull() {
            addCriterion("forever_rate is null");
            return (Criteria) this;
        }

        public Criteria andForeverRateIsNotNull() {
            addCriterion("forever_rate is not null");
            return (Criteria) this;
        }

        public Criteria andForeverRateEqualTo(BigDecimal value) {
            addCriterion("forever_rate =", value, "foreverRate");
            return (Criteria) this;
        }

        public Criteria andForeverRateNotEqualTo(BigDecimal value) {
            addCriterion("forever_rate <>", value, "foreverRate");
            return (Criteria) this;
        }

        public Criteria andForeverRateGreaterThan(BigDecimal value) {
            addCriterion("forever_rate >", value, "foreverRate");
            return (Criteria) this;
        }

        public Criteria andForeverRateGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("forever_rate >=", value, "foreverRate");
            return (Criteria) this;
        }

        public Criteria andForeverRateLessThan(BigDecimal value) {
            addCriterion("forever_rate <", value, "foreverRate");
            return (Criteria) this;
        }

        public Criteria andForeverRateLessThanOrEqualTo(BigDecimal value) {
            addCriterion("forever_rate <=", value, "foreverRate");
            return (Criteria) this;
        }

        public Criteria andForeverRateIn(List<BigDecimal> values) {
            addCriterion("forever_rate in", values, "foreverRate");
            return (Criteria) this;
        }

        public Criteria andForeverRateNotIn(List<BigDecimal> values) {
            addCriterion("forever_rate not in", values, "foreverRate");
            return (Criteria) this;
        }

        public Criteria andForeverRateBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("forever_rate between", value1, value2, "foreverRate");
            return (Criteria) this;
        }

        public Criteria andForeverRateNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("forever_rate not between", value1, value2, "foreverRate");
            return (Criteria) this;
        }

        public Criteria andShareRateIsNull() {
            addCriterion("share_rate is null");
            return (Criteria) this;
        }

        public Criteria andShareRateIsNotNull() {
            addCriterion("share_rate is not null");
            return (Criteria) this;
        }

        public Criteria andShareRateEqualTo(BigDecimal value) {
            addCriterion("share_rate =", value, "shareRate");
            return (Criteria) this;
        }

        public Criteria andShareRateNotEqualTo(BigDecimal value) {
            addCriterion("share_rate <>", value, "shareRate");
            return (Criteria) this;
        }

        public Criteria andShareRateGreaterThan(BigDecimal value) {
            addCriterion("share_rate >", value, "shareRate");
            return (Criteria) this;
        }

        public Criteria andShareRateGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("share_rate >=", value, "shareRate");
            return (Criteria) this;
        }

        public Criteria andShareRateLessThan(BigDecimal value) {
            addCriterion("share_rate <", value, "shareRate");
            return (Criteria) this;
        }

        public Criteria andShareRateLessThanOrEqualTo(BigDecimal value) {
            addCriterion("share_rate <=", value, "shareRate");
            return (Criteria) this;
        }

        public Criteria andShareRateIn(List<BigDecimal> values) {
            addCriterion("share_rate in", values, "shareRate");
            return (Criteria) this;
        }

        public Criteria andShareRateNotIn(List<BigDecimal> values) {
            addCriterion("share_rate not in", values, "shareRate");
            return (Criteria) this;
        }

        public Criteria andShareRateBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("share_rate between", value1, value2, "shareRate");
            return (Criteria) this;
        }

        public Criteria andShareRateNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("share_rate not between", value1, value2, "shareRate");
            return (Criteria) this;
        }

        public Criteria andRemarkIsNull() {
            addCriterion("remark is null");
            return (Criteria) this;
        }

        public Criteria andRemarkIsNotNull() {
            addCriterion("remark is not null");
            return (Criteria) this;
        }

        public Criteria andRemarkEqualTo(String value) {
            addCriterion("remark =", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkNotEqualTo(String value) {
            addCriterion("remark <>", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkGreaterThan(String value) {
            addCriterion("remark >", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkGreaterThanOrEqualTo(String value) {
            addCriterion("remark >=", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkLessThan(String value) {
            addCriterion("remark <", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkLessThanOrEqualTo(String value) {
            addCriterion("remark <=", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkLike(String value) {
            addCriterion("remark like", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkNotLike(String value) {
            addCriterion("remark not like", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkIn(List<String> values) {
            addCriterion("remark in", values, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkNotIn(List<String> values) {
            addCriterion("remark not in", values, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkBetween(String value1, String value2) {
            addCriterion("remark between", value1, value2, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkNotBetween(String value1, String value2) {
            addCriterion("remark not between", value1, value2, "remark");
            return (Criteria) this;
        }

        public Criteria andProductIdIsNull() {
            addCriterion("product_id is null");
            return (Criteria) this;
        }

        public Criteria andProductIdIsNotNull() {
            addCriterion("product_id is not null");
            return (Criteria) this;
        }

        public Criteria andProductIdEqualTo(Long value) {
            addCriterion("product_id =", value, "productId");
            return (Criteria) this;
        }

        public Criteria andProductIdNotEqualTo(Long value) {
            addCriterion("product_id <>", value, "productId");
            return (Criteria) this;
        }

        public Criteria andProductIdGreaterThan(Long value) {
            addCriterion("product_id >", value, "productId");
            return (Criteria) this;
        }

        public Criteria andProductIdGreaterThanOrEqualTo(Long value) {
            addCriterion("product_id >=", value, "productId");
            return (Criteria) this;
        }

        public Criteria andProductIdLessThan(Long value) {
            addCriterion("product_id <", value, "productId");
            return (Criteria) this;
        }

        public Criteria andProductIdLessThanOrEqualTo(Long value) {
            addCriterion("product_id <=", value, "productId");
            return (Criteria) this;
        }

        public Criteria andProductIdIn(List<Long> values) {
            addCriterion("product_id in", values, "productId");
            return (Criteria) this;
        }

        public Criteria andProductIdNotIn(List<Long> values) {
            addCriterion("product_id not in", values, "productId");
            return (Criteria) this;
        }

        public Criteria andProductIdBetween(Long value1, Long value2) {
            addCriterion("product_id between", value1, value2, "productId");
            return (Criteria) this;
        }

        public Criteria andProductIdNotBetween(Long value1, Long value2) {
            addCriterion("product_id not between", value1, value2, "productId");
            return (Criteria) this;
        }

        public Criteria andProductCodeIsNull() {
            addCriterion("product_code is null");
            return (Criteria) this;
        }

        public Criteria andProductCodeIsNotNull() {
            addCriterion("product_code is not null");
            return (Criteria) this;
        }

        public Criteria andProductCodeEqualTo(String value) {
            addCriterion("product_code =", value, "productCode");
            return (Criteria) this;
        }

        public Criteria andProductCodeNotEqualTo(String value) {
            addCriterion("product_code <>", value, "productCode");
            return (Criteria) this;
        }

        public Criteria andProductCodeGreaterThan(String value) {
            addCriterion("product_code >", value, "productCode");
            return (Criteria) this;
        }

        public Criteria andProductCodeGreaterThanOrEqualTo(String value) {
            addCriterion("product_code >=", value, "productCode");
            return (Criteria) this;
        }

        public Criteria andProductCodeLessThan(String value) {
            addCriterion("product_code <", value, "productCode");
            return (Criteria) this;
        }

        public Criteria andProductCodeLessThanOrEqualTo(String value) {
            addCriterion("product_code <=", value, "productCode");
            return (Criteria) this;
        }

        public Criteria andProductCodeLike(String value) {
            addCriterion("product_code like", value, "productCode");
            return (Criteria) this;
        }

        public Criteria andProductCodeNotLike(String value) {
            addCriterion("product_code not like", value, "productCode");
            return (Criteria) this;
        }

        public Criteria andProductCodeIn(List<String> values) {
            addCriterion("product_code in", values, "productCode");
            return (Criteria) this;
        }

        public Criteria andProductCodeNotIn(List<String> values) {
            addCriterion("product_code not in", values, "productCode");
            return (Criteria) this;
        }

        public Criteria andProductCodeBetween(String value1, String value2) {
            addCriterion("product_code between", value1, value2, "productCode");
            return (Criteria) this;
        }

        public Criteria andProductCodeNotBetween(String value1, String value2) {
            addCriterion("product_code not between", value1, value2, "productCode");
            return (Criteria) this;
        }

        public Criteria andYhqDisPriceIsNull() {
            addCriterion("yhq_dis_price is null");
            return (Criteria) this;
        }

        public Criteria andYhqDisPriceIsNotNull() {
            addCriterion("yhq_dis_price is not null");
            return (Criteria) this;
        }

        public Criteria andYhqDisPriceEqualTo(BigDecimal value) {
            addCriterion("yhq_dis_price =", value, "yhqDisPrice");
            return (Criteria) this;
        }

        public Criteria andYhqDisPriceNotEqualTo(BigDecimal value) {
            addCriterion("yhq_dis_price <>", value, "yhqDisPrice");
            return (Criteria) this;
        }

        public Criteria andYhqDisPriceGreaterThan(BigDecimal value) {
            addCriterion("yhq_dis_price >", value, "yhqDisPrice");
            return (Criteria) this;
        }

        public Criteria andYhqDisPriceGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("yhq_dis_price >=", value, "yhqDisPrice");
            return (Criteria) this;
        }

        public Criteria andYhqDisPriceLessThan(BigDecimal value) {
            addCriterion("yhq_dis_price <", value, "yhqDisPrice");
            return (Criteria) this;
        }

        public Criteria andYhqDisPriceLessThanOrEqualTo(BigDecimal value) {
            addCriterion("yhq_dis_price <=", value, "yhqDisPrice");
            return (Criteria) this;
        }

        public Criteria andYhqDisPriceIn(List<BigDecimal> values) {
            addCriterion("yhq_dis_price in", values, "yhqDisPrice");
            return (Criteria) this;
        }

        public Criteria andYhqDisPriceNotIn(List<BigDecimal> values) {
            addCriterion("yhq_dis_price not in", values, "yhqDisPrice");
            return (Criteria) this;
        }

        public Criteria andYhqDisPriceBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("yhq_dis_price between", value1, value2, "yhqDisPrice");
            return (Criteria) this;
        }

        public Criteria andYhqDisPriceNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("yhq_dis_price not between", value1, value2, "yhqDisPrice");
            return (Criteria) this;
        }

        public Criteria andMjDisPriceIsNull() {
            addCriterion("mj_dis_price is null");
            return (Criteria) this;
        }

        public Criteria andMjDisPriceIsNotNull() {
            addCriterion("mj_dis_price is not null");
            return (Criteria) this;
        }

        public Criteria andMjDisPriceEqualTo(BigDecimal value) {
            addCriterion("mj_dis_price =", value, "mjDisPrice");
            return (Criteria) this;
        }

        public Criteria andMjDisPriceNotEqualTo(BigDecimal value) {
            addCriterion("mj_dis_price <>", value, "mjDisPrice");
            return (Criteria) this;
        }

        public Criteria andMjDisPriceGreaterThan(BigDecimal value) {
            addCriterion("mj_dis_price >", value, "mjDisPrice");
            return (Criteria) this;
        }

        public Criteria andMjDisPriceGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("mj_dis_price >=", value, "mjDisPrice");
            return (Criteria) this;
        }

        public Criteria andMjDisPriceLessThan(BigDecimal value) {
            addCriterion("mj_dis_price <", value, "mjDisPrice");
            return (Criteria) this;
        }

        public Criteria andMjDisPriceLessThanOrEqualTo(BigDecimal value) {
            addCriterion("mj_dis_price <=", value, "mjDisPrice");
            return (Criteria) this;
        }

        public Criteria andMjDisPriceIn(List<BigDecimal> values) {
            addCriterion("mj_dis_price in", values, "mjDisPrice");
            return (Criteria) this;
        }

        public Criteria andMjDisPriceNotIn(List<BigDecimal> values) {
            addCriterion("mj_dis_price not in", values, "mjDisPrice");
            return (Criteria) this;
        }

        public Criteria andMjDisPriceBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("mj_dis_price between", value1, value2, "mjDisPrice");
            return (Criteria) this;
        }

        public Criteria andMjDisPriceNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("mj_dis_price not between", value1, value2, "mjDisPrice");
            return (Criteria) this;
        }

        public Criteria andBmDisPriceIsNull() {
            addCriterion("bm_dis_price is null");
            return (Criteria) this;
        }

        public Criteria andBmDisPriceIsNotNull() {
            addCriterion("bm_dis_price is not null");
            return (Criteria) this;
        }

        public Criteria andBmDisPriceEqualTo(BigDecimal value) {
            addCriterion("bm_dis_price =", value, "bmDisPrice");
            return (Criteria) this;
        }

        public Criteria andBmDisPriceNotEqualTo(BigDecimal value) {
            addCriterion("bm_dis_price <>", value, "bmDisPrice");
            return (Criteria) this;
        }

        public Criteria andBmDisPriceGreaterThan(BigDecimal value) {
            addCriterion("bm_dis_price >", value, "bmDisPrice");
            return (Criteria) this;
        }

        public Criteria andBmDisPriceGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("bm_dis_price >=", value, "bmDisPrice");
            return (Criteria) this;
        }

        public Criteria andBmDisPriceLessThan(BigDecimal value) {
            addCriterion("bm_dis_price <", value, "bmDisPrice");
            return (Criteria) this;
        }

        public Criteria andBmDisPriceLessThanOrEqualTo(BigDecimal value) {
            addCriterion("bm_dis_price <=", value, "bmDisPrice");
            return (Criteria) this;
        }

        public Criteria andBmDisPriceIn(List<BigDecimal> values) {
            addCriterion("bm_dis_price in", values, "bmDisPrice");
            return (Criteria) this;
        }

        public Criteria andBmDisPriceNotIn(List<BigDecimal> values) {
            addCriterion("bm_dis_price not in", values, "bmDisPrice");
            return (Criteria) this;
        }

        public Criteria andBmDisPriceBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("bm_dis_price between", value1, value2, "bmDisPrice");
            return (Criteria) this;
        }

        public Criteria andBmDisPriceNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("bm_dis_price not between", value1, value2, "bmDisPrice");
            return (Criteria) this;
        }

        public Criteria andAccountPriceIsNull() {
            addCriterion("account_price is null");
            return (Criteria) this;
        }

        public Criteria andAccountPriceIsNotNull() {
            addCriterion("account_price is not null");
            return (Criteria) this;
        }

        public Criteria andAccountPriceEqualTo(BigDecimal value) {
            addCriterion("account_price =", value, "accountPrice");
            return (Criteria) this;
        }

        public Criteria andAccountPriceNotEqualTo(BigDecimal value) {
            addCriterion("account_price <>", value, "accountPrice");
            return (Criteria) this;
        }

        public Criteria andAccountPriceGreaterThan(BigDecimal value) {
            addCriterion("account_price >", value, "accountPrice");
            return (Criteria) this;
        }

        public Criteria andAccountPriceGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("account_price >=", value, "accountPrice");
            return (Criteria) this;
        }

        public Criteria andAccountPriceLessThan(BigDecimal value) {
            addCriterion("account_price <", value, "accountPrice");
            return (Criteria) this;
        }

        public Criteria andAccountPriceLessThanOrEqualTo(BigDecimal value) {
            addCriterion("account_price <=", value, "accountPrice");
            return (Criteria) this;
        }

        public Criteria andAccountPriceIn(List<BigDecimal> values) {
            addCriterion("account_price in", values, "accountPrice");
            return (Criteria) this;
        }

        public Criteria andAccountPriceNotIn(List<BigDecimal> values) {
            addCriterion("account_price not in", values, "accountPrice");
            return (Criteria) this;
        }

        public Criteria andAccountPriceBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("account_price between", value1, value2, "accountPrice");
            return (Criteria) this;
        }

        public Criteria andAccountPriceNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("account_price not between", value1, value2, "accountPrice");
            return (Criteria) this;
        }

        public Criteria andExpressPriceIsNull() {
            addCriterion("express_price is null");
            return (Criteria) this;
        }

        public Criteria andExpressPriceIsNotNull() {
            addCriterion("express_price is not null");
            return (Criteria) this;
        }

        public Criteria andExpressPriceEqualTo(BigDecimal value) {
            addCriterion("express_price =", value, "expressPrice");
            return (Criteria) this;
        }

        public Criteria andExpressPriceNotEqualTo(BigDecimal value) {
            addCriterion("express_price <>", value, "expressPrice");
            return (Criteria) this;
        }

        public Criteria andExpressPriceGreaterThan(BigDecimal value) {
            addCriterion("express_price >", value, "expressPrice");
            return (Criteria) this;
        }

        public Criteria andExpressPriceGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("express_price >=", value, "expressPrice");
            return (Criteria) this;
        }

        public Criteria andExpressPriceLessThan(BigDecimal value) {
            addCriterion("express_price <", value, "expressPrice");
            return (Criteria) this;
        }

        public Criteria andExpressPriceLessThanOrEqualTo(BigDecimal value) {
            addCriterion("express_price <=", value, "expressPrice");
            return (Criteria) this;
        }

        public Criteria andExpressPriceIn(List<BigDecimal> values) {
            addCriterion("express_price in", values, "expressPrice");
            return (Criteria) this;
        }

        public Criteria andExpressPriceNotIn(List<BigDecimal> values) {
            addCriterion("express_price not in", values, "expressPrice");
            return (Criteria) this;
        }

        public Criteria andExpressPriceBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("express_price between", value1, value2, "expressPrice");
            return (Criteria) this;
        }

        public Criteria andExpressPriceNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("express_price not between", value1, value2, "expressPrice");
            return (Criteria) this;
        }

        public Criteria andPackDisPriceIsNull() {
            addCriterion("pack_dis_price is null");
            return (Criteria) this;
        }

        public Criteria andPackDisPriceIsNotNull() {
            addCriterion("pack_dis_price is not null");
            return (Criteria) this;
        }

        public Criteria andPackDisPriceEqualTo(BigDecimal value) {
            addCriterion("pack_dis_price =", value, "packDisPrice");
            return (Criteria) this;
        }

        public Criteria andPackDisPriceNotEqualTo(BigDecimal value) {
            addCriterion("pack_dis_price <>", value, "packDisPrice");
            return (Criteria) this;
        }

        public Criteria andPackDisPriceGreaterThan(BigDecimal value) {
            addCriterion("pack_dis_price >", value, "packDisPrice");
            return (Criteria) this;
        }

        public Criteria andPackDisPriceGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("pack_dis_price >=", value, "packDisPrice");
            return (Criteria) this;
        }

        public Criteria andPackDisPriceLessThan(BigDecimal value) {
            addCriterion("pack_dis_price <", value, "packDisPrice");
            return (Criteria) this;
        }

        public Criteria andPackDisPriceLessThanOrEqualTo(BigDecimal value) {
            addCriterion("pack_dis_price <=", value, "packDisPrice");
            return (Criteria) this;
        }

        public Criteria andPackDisPriceIn(List<BigDecimal> values) {
            addCriterion("pack_dis_price in", values, "packDisPrice");
            return (Criteria) this;
        }

        public Criteria andPackDisPriceNotIn(List<BigDecimal> values) {
            addCriterion("pack_dis_price not in", values, "packDisPrice");
            return (Criteria) this;
        }

        public Criteria andPackDisPriceBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("pack_dis_price between", value1, value2, "packDisPrice");
            return (Criteria) this;
        }

        public Criteria andPackDisPriceNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("pack_dis_price not between", value1, value2, "packDisPrice");
            return (Criteria) this;
        }

        public Criteria andPromotionRemarkIsNull() {
            addCriterion("promotion_remark is null");
            return (Criteria) this;
        }

        public Criteria andPromotionRemarkIsNotNull() {
            addCriterion("promotion_remark is not null");
            return (Criteria) this;
        }

        public Criteria andPromotionRemarkEqualTo(String value) {
            addCriterion("promotion_remark =", value, "promotionRemark");
            return (Criteria) this;
        }

        public Criteria andPromotionRemarkNotEqualTo(String value) {
            addCriterion("promotion_remark <>", value, "promotionRemark");
            return (Criteria) this;
        }

        public Criteria andPromotionRemarkGreaterThan(String value) {
            addCriterion("promotion_remark >", value, "promotionRemark");
            return (Criteria) this;
        }

        public Criteria andPromotionRemarkGreaterThanOrEqualTo(String value) {
            addCriterion("promotion_remark >=", value, "promotionRemark");
            return (Criteria) this;
        }

        public Criteria andPromotionRemarkLessThan(String value) {
            addCriterion("promotion_remark <", value, "promotionRemark");
            return (Criteria) this;
        }

        public Criteria andPromotionRemarkLessThanOrEqualTo(String value) {
            addCriterion("promotion_remark <=", value, "promotionRemark");
            return (Criteria) this;
        }

        public Criteria andPromotionRemarkLike(String value) {
            addCriterion("promotion_remark like", value, "promotionRemark");
            return (Criteria) this;
        }

        public Criteria andPromotionRemarkNotLike(String value) {
            addCriterion("promotion_remark not like", value, "promotionRemark");
            return (Criteria) this;
        }

        public Criteria andPromotionRemarkIn(List<String> values) {
            addCriterion("promotion_remark in", values, "promotionRemark");
            return (Criteria) this;
        }

        public Criteria andPromotionRemarkNotIn(List<String> values) {
            addCriterion("promotion_remark not in", values, "promotionRemark");
            return (Criteria) this;
        }

        public Criteria andPromotionRemarkBetween(String value1, String value2) {
            addCriterion("promotion_remark between", value1, value2, "promotionRemark");
            return (Criteria) this;
        }

        public Criteria andPromotionRemarkNotBetween(String value1, String value2) {
            addCriterion("promotion_remark not between", value1, value2, "promotionRemark");
            return (Criteria) this;
        }

        public Criteria andVipDisPriceIsNull() {
            addCriterion("vip_dis_price is null");
            return (Criteria) this;
        }

        public Criteria andVipDisPriceIsNotNull() {
            addCriterion("vip_dis_price is not null");
            return (Criteria) this;
        }

        public Criteria andVipDisPriceEqualTo(BigDecimal value) {
            addCriterion("vip_dis_price =", value, "vipDisPrice");
            return (Criteria) this;
        }

        public Criteria andVipDisPriceNotEqualTo(BigDecimal value) {
            addCriterion("vip_dis_price <>", value, "vipDisPrice");
            return (Criteria) this;
        }

        public Criteria andVipDisPriceGreaterThan(BigDecimal value) {
            addCriterion("vip_dis_price >", value, "vipDisPrice");
            return (Criteria) this;
        }

        public Criteria andVipDisPriceGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("vip_dis_price >=", value, "vipDisPrice");
            return (Criteria) this;
        }

        public Criteria andVipDisPriceLessThan(BigDecimal value) {
            addCriterion("vip_dis_price <", value, "vipDisPrice");
            return (Criteria) this;
        }

        public Criteria andVipDisPriceLessThanOrEqualTo(BigDecimal value) {
            addCriterion("vip_dis_price <=", value, "vipDisPrice");
            return (Criteria) this;
        }

        public Criteria andVipDisPriceIn(List<BigDecimal> values) {
            addCriterion("vip_dis_price in", values, "vipDisPrice");
            return (Criteria) this;
        }

        public Criteria andVipDisPriceNotIn(List<BigDecimal> values) {
            addCriterion("vip_dis_price not in", values, "vipDisPrice");
            return (Criteria) this;
        }

        public Criteria andVipDisPriceBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("vip_dis_price between", value1, value2, "vipDisPrice");
            return (Criteria) this;
        }

        public Criteria andVipDisPriceNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("vip_dis_price not between", value1, value2, "vipDisPrice");
            return (Criteria) this;
        }

        public Criteria andCostPriceIsNull() {
            addCriterion("cost_price is null");
            return (Criteria) this;
        }

        public Criteria andCostPriceIsNotNull() {
            addCriterion("cost_price is not null");
            return (Criteria) this;
        }

        public Criteria andCostPriceEqualTo(BigDecimal value) {
            addCriterion("cost_price =", value, "costPrice");
            return (Criteria) this;
        }

        public Criteria andCostPriceNotEqualTo(BigDecimal value) {
            addCriterion("cost_price <>", value, "costPrice");
            return (Criteria) this;
        }

        public Criteria andCostPriceGreaterThan(BigDecimal value) {
            addCriterion("cost_price >", value, "costPrice");
            return (Criteria) this;
        }

        public Criteria andCostPriceGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("cost_price >=", value, "costPrice");
            return (Criteria) this;
        }

        public Criteria andCostPriceLessThan(BigDecimal value) {
            addCriterion("cost_price <", value, "costPrice");
            return (Criteria) this;
        }

        public Criteria andCostPriceLessThanOrEqualTo(BigDecimal value) {
            addCriterion("cost_price <=", value, "costPrice");
            return (Criteria) this;
        }

        public Criteria andCostPriceIn(List<BigDecimal> values) {
            addCriterion("cost_price in", values, "costPrice");
            return (Criteria) this;
        }

        public Criteria andCostPriceNotIn(List<BigDecimal> values) {
            addCriterion("cost_price not in", values, "costPrice");
            return (Criteria) this;
        }

        public Criteria andCostPriceBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("cost_price between", value1, value2, "costPrice");
            return (Criteria) this;
        }

        public Criteria andCostPriceNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("cost_price not between", value1, value2, "costPrice");
            return (Criteria) this;
        }

        public Criteria andNewCustomDisPriceIsNull() {
            addCriterion("new_custom_dis_price is null");
            return (Criteria) this;
        }

        public Criteria andNewCustomDisPriceIsNotNull() {
            addCriterion("new_custom_dis_price is not null");
            return (Criteria) this;
        }

        public Criteria andNewCustomDisPriceEqualTo(BigDecimal value) {
            addCriterion("new_custom_dis_price =", value, "newCustomDisPrice");
            return (Criteria) this;
        }

        public Criteria andNewCustomDisPriceNotEqualTo(BigDecimal value) {
            addCriterion("new_custom_dis_price <>", value, "newCustomDisPrice");
            return (Criteria) this;
        }

        public Criteria andNewCustomDisPriceGreaterThan(BigDecimal value) {
            addCriterion("new_custom_dis_price >", value, "newCustomDisPrice");
            return (Criteria) this;
        }

        public Criteria andNewCustomDisPriceGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("new_custom_dis_price >=", value, "newCustomDisPrice");
            return (Criteria) this;
        }

        public Criteria andNewCustomDisPriceLessThan(BigDecimal value) {
            addCriterion("new_custom_dis_price <", value, "newCustomDisPrice");
            return (Criteria) this;
        }

        public Criteria andNewCustomDisPriceLessThanOrEqualTo(BigDecimal value) {
            addCriterion("new_custom_dis_price <=", value, "newCustomDisPrice");
            return (Criteria) this;
        }

        public Criteria andNewCustomDisPriceIn(List<BigDecimal> values) {
            addCriterion("new_custom_dis_price in", values, "newCustomDisPrice");
            return (Criteria) this;
        }

        public Criteria andNewCustomDisPriceNotIn(List<BigDecimal> values) {
            addCriterion("new_custom_dis_price not in", values, "newCustomDisPrice");
            return (Criteria) this;
        }

        public Criteria andNewCustomDisPriceBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("new_custom_dis_price between", value1, value2, "newCustomDisPrice");
            return (Criteria) this;
        }

        public Criteria andNewCustomDisPriceNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("new_custom_dis_price not between", value1, value2, "newCustomDisPrice");
            return (Criteria) this;
        }

        public Criteria andRealPriceIsNull() {
            addCriterion("real_price is null");
            return (Criteria) this;
        }

        public Criteria andRealPriceIsNotNull() {
            addCriterion("real_price is not null");
            return (Criteria) this;
        }

        public Criteria andRealPriceEqualTo(BigDecimal value) {
            addCriterion("real_price =", value, "realPrice");
            return (Criteria) this;
        }

        public Criteria andRealPriceNotEqualTo(BigDecimal value) {
            addCriterion("real_price <>", value, "realPrice");
            return (Criteria) this;
        }

        public Criteria andRealPriceGreaterThan(BigDecimal value) {
            addCriterion("real_price >", value, "realPrice");
            return (Criteria) this;
        }

        public Criteria andRealPriceGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("real_price >=", value, "realPrice");
            return (Criteria) this;
        }

        public Criteria andRealPriceLessThan(BigDecimal value) {
            addCriterion("real_price <", value, "realPrice");
            return (Criteria) this;
        }

        public Criteria andRealPriceLessThanOrEqualTo(BigDecimal value) {
            addCriterion("real_price <=", value, "realPrice");
            return (Criteria) this;
        }

        public Criteria andRealPriceIn(List<BigDecimal> values) {
            addCriterion("real_price in", values, "realPrice");
            return (Criteria) this;
        }

        public Criteria andRealPriceNotIn(List<BigDecimal> values) {
            addCriterion("real_price not in", values, "realPrice");
            return (Criteria) this;
        }

        public Criteria andRealPriceBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("real_price between", value1, value2, "realPrice");
            return (Criteria) this;
        }

        public Criteria andRealPriceNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("real_price not between", value1, value2, "realPrice");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}